<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
    
<%@page import="br.com.bean.AlunoBean"%>
<%@page import="br.com.controller.AlunoController"%>
<%@page import="br.com.connection.ConnectionFactory"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.util.List"%>

<%Connection conn = new ConnectionFactory().getConnection();%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>

<%
String nome = request.getParameter("id");
List<AlunoBean> info = AlunoController.infoAluno(conn, nome);
for (AlunoBean i : info){
%>
<p><b class="laranja">Nome da Mãe: </b><%=i.getMae() %><br />
<b class="laranja">Endereço: </b><%=i.getEnd() %><br />
<b class="laranja">Bairro: </b><%=i.getBairro() %><br />
<b class="laranja">Cidade: </b><%=i.getCidade().getCidade() %><br />
<b class="laranja">Estado: </b><%=i.getEstado().getEstado() %><br />
<b class="laranja">Telefone: </b><%=i.getTel() %><br /></p>
<%} %>

</body>
</html>